class CreateGuias < ActiveRecord::Migration
  def self.up
    create_table :guias do |t|
      t.column :numeroguiaprincipal, :integer, :null => false, :limit => 20
#      t.column :dataemissaoguia, :datetime, :null => false
#      t.column :numerocarteirabeneficiario, :integer, :null => false, :limit => 20
#      t.column :nomebeneficiario, :string, :null => false
#      t.column :operadorabeneficiario, :integer, :null => false
#      t.column :validadecarteirabeneficiario, :datetime, :nul => false
#      t.column :nomecontratadosolic, :string, :null => false
#      t.columm :siglaconselhosolic, :string, :null => false
#      t.column :numeroconselhosolic, :integer, :null => false, :limit => 15
#      t.column :ufconselhosolic, :string, :null => false
#      t.column :nomecontratadoexec, :string, :null => false
#      t.column :codigoprestadornaoperadoraexec, :integer, :null => false, :limit => 20
#      t.column :numerocnesexec, :integer, :null => false, :limit => 20
#      t.column :siglaconselhoexec, :string, :null => false
#      t.column :numeroconselhoexec, :integer, :null => false, :limit => 15
#      t.column :ufconselhoexec, :string, :null => false
#      t.column :carateratendimento, :string, :null => false
#      t.column :tiposaida, :integer, :null => false
#      t.column :tipoatendimento, :integer, :null => false
#      t.column :operadora_id, :integer, :null => false
#      t.column :empresa_id, :integer, :null => false
    end
  end

  def self.down
    drop_table :guias
  end
end
